<CFQUERY name="getpriorities" datasource="#application.dsn#">
SELECT * FROM priorities
</CFQUERY>
<FORM action="/codesaver/index.cfm" method="post">
	<SELECT name="priorities" size="1">
	<OPTION value="0"> Select priorities
	<CFOUTPUT query="getpriorities">
	<OPTION value="#priorityid#">#priority#</OPTION>
	</CFOUTPUT>
	</SELECT>
</FORM>
